Python Phrasebook - Essential Code and Commands by By

Author:By
Language: eng
Format: epub
ISBN: 0-672-32910-7
Publisher: Sams
Published: 2011-10-03T16:06:11.594400+00:00

import MySQLdb #Connect to MySQL Server myDB = MySQLdb.connect(host="127.0.0.1", \ port=3306) cHandler = myDB.cursor() #Display available databases cHandler.execute("SHOW DATABASES") results = cHandler.fetchall() print"Databases\n=====================" for item in results: print item[0] #Display current database cHandler.execute("SELECT DATABASE()") results = cHandler.fetchall() print "\nCurrent Database\n=======================" for item in results: print item[0] #Select database cHandler.execute("USE schedule") #Display current database cHandler.execute("SELECT DATABASE()") results = cHandler.fetchall() print "\nCurrent Database\n=======================" for item in results: print item[0] myDB.close()

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.